class CreateGradeEntries < ActiveRecord::Migration
  def self.up
    create_table :grade_entries do |t|
      t.integer :person_id, :null => false, :options => "CONSTRAINT fk_grade_entry_people REFERENCES people(id)"      
      t.integer :assignment_id, :null => false, :options => "CONSTRAINT fk_grade_entry_assignments REFERENCES assignemnts(id)"
      t.decimal :grade, :null => false

      t.timestamps
    end
  end

  def self.down
    drop_table :grade_entries
  end
end
